QCC Data Warehouse

What’s the value add of the data warehouse?

• Effective dating

• Snapshots

• Automation

• User friendly interface

Effective Dating

• But CUNY First has effective dates

Effective Dating in CUNY First

• Many CUNY First tables don’t have effective dates

  • class section data

    • changes in status

    • changes in capacity

• Very few tables have effective end dates

  • Admissions pipeline

• Effective end dates are inconsistent

  • stdnt_enrl

Effective Dating in Data Warehouse

• Create end dates for effective dated fields

• Create deleted status for deleted fields

• Generate effective dates where previously nonexistant

Snapshots

Snapshots

• Historical static views of CUNY First at specified points in history

  • Census date
  • First day of term
  • Current offset
  • Etc.

Automation

Automation

• IT has this all set up automatically

• The reporting instance query

• Extraction from tumbleweed

• The effective dating

• The snapshots

User Interface

• OBIEE web app interface

• Abstracts away leftover complexity of datawarehouse

• No SQL required

• Drag and drop gui